/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 50525
Source Host           : localhost:3306
Source Database       : demo

Target Server Type    : MYSQL
Target Server Version : 50525
File Encoding         : 65001

Date: 2023-05-05 18:02:59
*/

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
                        `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
                        `user_id` varchar(32) DEFAULT NULL COMMENT '用户名',
                        `user_name` varchar(255) DEFAULT NULL COMMENT '昵称',
                        `age` int(11) DEFAULT NULL COMMENT '年龄',
                        `address` varchar(128) DEFAULT NULL COMMENT '地址',
                        `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                        `password` varchar(64) DEFAULT NULL COMMENT '密码',
                        `dept_id` int(11) DEFAULT NULL COMMENT '部门ID',
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'halo1ddddd', '哈喽ddsda', 12, '安徽合肥', '2023-05-06 14:45:57', '123456', 1);
INSERT INTO `user` VALUES (10, 'summ', 'SUM嘿', 11, '上海', '2023-07-21 16:04:34', NULL, 2);
INSERT INTO `user` VALUES (11, 'summ111', 'SUM嘿11', 2, '北京', '2023-07-21 16:14:49', NULL, 2);
INSERT INTO `user` VALUES (12, 'summ13232', '32323', 22, '湖州', '2023-07-21 16:18:00', NULL, 1);
INSERT INTO `user` VALUES (13, 'summ13232', '32323', 33, '天津', '2023-07-21 16:23:32', NULL, 2);
INSERT INTO `user` VALUES (14, 'summ1212', '12122', 33, '福建厦门', '2023-07-21 16:26:48', NULL, 1);
INSERT INTO `user` VALUES (15, 'summ1212', '2122222', 11, '兰州', '2023-07-21 16:31:06', NULL, 2);
INSERT INTO `user` VALUES (16, 'summ1212', '2122222', 22, '青海', '2023-07-21 16:34:21', NULL, 1);
INSERT INTO `user` VALUES (17, 'hhhh', 'lallala', 11, '河南郑州', '2023-07-21 16:34:59', NULL, 2);
INSERT INTO `user` VALUES (18, '点点滴滴', '1111', 11, '222', '2023-07-24 09:23:40', NULL, 2);
INSERT INTO `user` VALUES (19, '分页', '11', 1, '1', '2023-07-24 09:23:48', NULL, 1);


-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
                        `id` int(11) NOT NULL AUTO_INCREMENT,
                        `dept_name` varchar(32) DEFAULT NULL,
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of dept
-- ----------------------------
BEGIN;
INSERT INTO `dept` VALUES (1, '行政部');
INSERT INTO `dept` VALUES (2, '管理部');
COMMIT;

